Tabela PhCompany

Definicja tabeli PhCompany

Name

PhCompany

Code

PhCompany

Comment

Firmy


Lista kolumn tabeli PhCompany

Name

Code

CompanyID

CompanyID

AddressID

AddressID

Name

Name

Description

Description

AddressText

AddressText

Nip

Nip

Regon

Regon

TelephoneNo

TelephoneNo

Email

Email

Code

Code

Deliverer

Deliverer

Producer

Producer

Active

Active

JwcID

JwcID

BazylID

BazylID

AccountingIdentifier

AccountingIdentifier

Contractor

Contractor

AnalyticAccount

AnalyticAccount

FaxNo

FaxNo

HashCode

HashCode

ExternalID

ExternalID

Code2

Code2

P4COMPANYID

P4COMPANYID

DrugVersion

DrugVersion


Kolumna CompanyID tabeli PhCompany

Definicja kolumny CompanyID tabeli PhCompany

Name

CompanyID

Code

CompanyID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AddressID tabeli PhCompany

Definicja kolumny AddressID tabeli PhCompany

Name

AddressID

Code

AddressID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Name tabeli PhCompany

Definicja kolumny Name tabeli PhCompany

Name

Name

Code

Name

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Nazwa


Kolumna Description tabeli PhCompany

Definicja kolumny Description tabeli PhCompany

Name

Description

Code

Description

Data Type

CLOB

Mandatory

No

Comment

Opis


Kolumna AddressText tabeli PhCompany

Definicja kolumny AddressText tabeli PhCompany

Name

AddressText

Code

AddressText

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Adres firmy


Kolumna Nip tabeli PhCompany

Definicja kolumny Nip tabeli PhCompany

Name

Nip

Code

Nip

Data Type

VARCHAR2(255)

Mandatory

No

Comment

NIP firmy


Kolumna Regon tabeli PhCompany

Definicja kolumny Regon tabeli PhCompany

Name

Regon

Code

Regon

Data Type

VARCHAR2(255)

Mandatory

No

Comment

REGON firmy


Kolumna TelephoneNo tabeli PhCompany

Definicja kolumny TelephoneNo tabeli PhCompany

Name

TelephoneNo

Code

TelephoneNo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Numer telefonu firmy


Kolumna Email tabeli PhCompany

Definicja kolumny Email tabeli PhCompany

Name

Email

Code

Email

Data Type

VARCHAR2(255)

Mandatory

No

Comment

E-mail firmy


Kolumna Code tabeli PhCompany

Definicja kolumny Code tabeli PhCompany

Name

Code

Code

Code

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Kod


Kolumna Deliverer tabeli PhCompany

Definicja kolumny Deliverer tabeli PhCompany

Name

Deliverer

Code

Deliverer

Data Type

NUMBER(3)

Mandatory

No

Comment

Warunkuje czy firma jest dostawca


Kolumna Producer tabeli PhCompany

Definicja kolumny Producer tabeli PhCompany

Name

Producer

Code

Producer

Data Type

NUMBER(3)

Mandatory

No

Comment

Warunkuje czy firma jest producentem


Kolumna Active tabeli PhCompany

Definicja kolumny Active tabeli PhCompany

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

No

Comment

Flaga aktywnosci w systemie


Kolumna JwcID tabeli PhCompany

Definicja kolumny JwcID tabeli PhCompany

Name

JwcID

Code

JwcID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID ze slownika JWC


Kolumna BazylID tabeli PhCompany

Definicja kolumny BazylID tabeli PhCompany

Name

BazylID

Code

BazylID

Data Type

VARCHAR2(6)

Mandatory

No

Comment

ID ze slownika BAZYL


Kolumna AccountingIdentifier tabeli PhCompany

Definicja kolumny AccountingIdentifier tabeli PhCompany

Name

AccountingIdentifier

Code

AccountingIdentifier

Data Type

VARCHAR2(20)

Mandatory

No

Comment

Identyfikator konta ksiegowego dla kontrahenta


Kolumna Contractor tabeli PhCompany

Definicja kolumny Contractor tabeli PhCompany

Name

Contractor

Code

Contractor

Data Type

NUMBER(3)

Mandatory

No

Comment

Informacja, czy dana firma jest kontrahentem


Kolumna AnalyticAccount tabeli PhCompany

Definicja kolumny AnalyticAccount tabeli PhCompany

Name

AnalyticAccount

Code

AnalyticAccount

Data Type

VARCHAR2(10)

Mandatory

No

Comment

Numer konta analitycznego


Kolumna FaxNo tabeli PhCompany

Definicja kolumny FaxNo tabeli PhCompany

Name

FaxNo

Code

FaxNo

Data Type

VARCHAR2(20)

Mandatory

No

Comment

Numer fax


Kolumna HashCode tabeli PhCompany

Definicja kolumny HashCode tabeli PhCompany

Name

HashCode

Code

HashCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Skrót z pól rekordu


Kolumna ExternalID tabeli PhCompany

Definicja kolumny ExternalID tabeli PhCompany

Name

ExternalID

Code

ExternalID

Data Type

VARCHAR2(12)

Mandatory

No

Comment

Zewnetrzny identyfikator


Kolumna Code2 tabeli PhCompany

Definicja kolumny Code2 tabeli PhCompany

Name

Code2

Code

Code2

Data Type

VARCHAR2(50)

Mandatory

No

Comment

dodatkowy numer dostawcy w Rosji


Kolumna P4COMPANYID tabeli PhCompany

Definicja kolumny P4COMPANYID tabeli PhCompany

Name

P4COMPANYID

Code

P4COMPANYID

Data Type

NUMBER(10)

Mandatory

No

Comment

Atrybut Company dla P4


Kolumna DrugVersion tabeli PhCompany

Definicja kolumny DrugVersion tabeli PhCompany

Name

DrugVersion

Code

DrugVersion

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli PhCompany

Name

Code

Primary

Key_1

Key_1

X


Klucz Key_1 tabeli PhCompany

Definicja klucza Key_1 tabeli PhCompany

Name

Key_1

Code

Key_1

Primary

Yes

Comment